Business Intelligence Specialist

2 weeks ago


Troy, United States OpTech Full time

OpTech is seeking for strong SQL Developer for their Direct client.


This is Hybrid role.

Rate - $45/hour on W2.


Job Description:

  • Proficient in usage of different analytical functions (Partition By, Rank, Sum, Group By, Order By clauses, Lead, Lag, etc…)
  • Optimize SQL queries/Performance Tuning è Integration and working with multiple sources/ different datasets
  • Expertise in using Nested, Sub and inner Queries and its appropriate usage
  • Experience in handling errors and fixing the SQL issues For an ideal candidate in Healthcare Domain: (Average to above average).
  • Healthcare domain is negotiable, someone might have other domain experience.


OpTech is an equal opportunity employer and is committed to creating a diverse environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, status as a parent, disability, age, veteran status, or other characteristics as defined by federal, state or local laws.



  • Troy, United States Proctor Loan Protector Full time

    Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers. Title: Business Intelligence (BI) Architect Status: Exempt Department: Client Technology Reports to: Vice President, Client Technology Who are we? What do we do? Company Overview: Proctor Loan Protector provides...


  • Troy, United States J.D. Power Full time

    Be where the voice of the consumer meets the value of the brand. At J.D. Power, you’ll be at the heart of commerce, working for a worldwide leader whose intelligence and insights are shaping the way people sell, and the way people buy. Who We Are Since 1968, companies around the world have trusted J.D. Power to generate and gather the consumer insights...

  • Office Assistant

    2 weeks ago


    Troy, United States C4H Building Specialist Full time

    Job DescriptionJob DescriptionWe are seeking an Office Administrator to join our team! You will perform clerical and administrative functions in order to drive company success.Responsibilities:Generate work orders for service technicians in the fieldAccounts payable/receivable Have lien waivers notarized when necessaryOrder materials required for...


  • Troy, United States Malace|HR Full time

    MalaceHR is seeking a Talent Acquisition Specialist that will be working in Troy, MI Job Description The Talent Acquisition Specialist focuses on the sourcing of candidates, establishing new sources, creating a talent pipeline, and implementing proactive recruiting initiatives. Job Responsibilities -Translate organizational needs within assigned region into...


  • Troy, United States Malace HR Full time

    Job DescriptionJob DescriptionMalaceHR is seeking a Talent Acquisition Specialist that will be working in Troy, MIJob DescriptionThe Talent Acquisition Specialist focuses on the sourcing of candidates, establishing new sources, creating a talent pipeline, and implementing proactive recruiting initiatives.Job Responsibilities-Translate organizational needs...


  • Troy, United States MDMartin Full time

    Job DescriptionJob DescriptionSummary:The Business Support Specialist (Contract) will provide support to expatriates and immigration support services to employees as needed. Will also provide administrative support by managing shared goods services and processing administrative tasks through internal and external systems while managing other General Affairs...


  • Troy, United States Security Operations Center-X Full time

    Job DescriptionJob DescriptionSecurity Operations Center-X is hiring full time or part time Security Monitoring Specialists. SOC-X is a new security technology company located in Troy, MI.Job PurposeThe Security Monitoring Specialist at SOCX is essential in protecting assets, personnel, and clients. This role demands a vigilant individual capable of managing...


  • Troy, United States Unified Business Technologies Inc. Full time

    Job DescriptionJob DescriptionAs a Construction Trades Sourcing Specialist, your primary responsibility will be to identify, evaluate, and negotiate with potential construction contractors and service trades in each state. You will play a crucial role in ensuring we work with the best tradespeople to meet our high standards and project requirements.


  • Troy, United States Unified Business Technologies Inc. Full time

    Job DescriptionJob DescriptionAs a Construction Trades Sourcing Specialist, your primary responsibility will be to identify, evaluate, and negotiate with potential construction contractors and service trades in each state. You will play a crucial role in ensuring we work with the best tradespeople to meet our high standards and project requirements.


  • Troy, United States Altair Full time

    Solutions Marketing Content Specialist Do you like a challenge, are you a complex thinker who likes to solve problems? If so, you might be the new Altairian we are seeking. At Altair, your curiosity matters. We pride ourselves on a business culture that enables open, creative thinking, and we deeply value our employees and their contributions towards our...


  • Troy, United States Altair Full time

    Solutions Marketing Content Specialist Do you like a challenge, are you a complex thinker who likes to solve problems? If so, you might be the new Altairian we are seeking. At Altair, your curiosity matters. We pride ourselves on a business culture that enables open, creative thinking, and we deeply value our employees and their contributions towards our...


  • Troy, United States Motherson SAS Full time

    The Motherson Group is one of the 21 largest and fastest growing full system solutions providers to the global automotive industry, serving multiple further industries, such as rolling stock, aerospace, medical, IT, and logistics, with over 160,000 employees across 41 countries worldwide.Motherson SAS specializes in the assembly, logistics, and development...


  • Troy, United States Motherson SAS Full time

    The Motherson Group is one of the 21 largest and fastest growing full system solutions providers to the global automotive industry, serving multiple further industries, such as rolling stock, aerospace, medical, IT, and logistics, with over 160,000 employees across 41 countries worldwide. Motherson SAS specializes in the assembly, logistics, and development...


  • Troy, United States Motherson SAS Full time

    The Motherson Group is one of the 21 largest and fastest growing full system solutions providers to the global automotive industry, serving multiple further industries, such as rolling stock, aerospace, medical, IT, and logistics, with over 160,000 employees across 41 countries worldwide.Motherson SAS specializes in the assembly, logistics, and development...

  • HR Specialist

    1 month ago


    Troy, Michigan, United States Magna International Full time

    Job Number: 66158 Group: Magna Electronics Division: Magna Electronics Auburn Hills Job Type: Permanent/Regular Location: AUBURN HILLS Work Style: About usWe see a future where everyone can live and move without limitations. That's why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities,...


  • Troy, United States Flagstar Bank Full time

    Flagstar Bank is seeking an individual to join our Special Loans Team as a Collateral Management Specialist. The Collateral Management area manages the release of collateral for assumptions, subordinations, easements, partial releases, land swaps, My Collateral, Management, Specialist, Business Partner, Banking, Investor


  • Troy, United States Hoefs Recruiting Solutions Full time

    Currently looking for a talented Technical Sales Specialist to fill an opening with a well-established automotive engineering company in the greater Troy, MI area. Interested candidates should have previous experience working with metal components - stampings, wireforms, springs, welded assemblies, etc.Responsibilities of the Technical Sales...


  • Troy, United States Hoefs Recruiting Solutions Full time

    Currently looking for a talented Technical Sales Specialist to fill an opening with a well-established automotive engineering company in the greater Troy, MI area. Interested candidates should have previous experience working with metal components - stampings, wireforms, springs, welded assemblies, etc.Responsibilities of the Technical Sales...


  • Troy, United States Hoefs Recruiting Solutions Full time

    Currently looking for a talented Technical Sales Specialist to fill an opening with a well-established automotive engineering company in the greater Troy, MI area. Interested candidates should have previous experience working with metal components - stampings, wireforms, springs, welded assemblies, etc.Responsibilities of the Technical Sales...

  • HR Specialist

    1 month ago


    Troy, United States Magna International Full time

    Job Number: 66158 Group: Magna Electronics Division: Magna Electronics Auburn Hills Job Type: Permanent/Regular Location: AUBURN HILLS Work Style: About usWe see a future where everyone can live and move without limitations. That's why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our...