T-SQL Data Analyst

Beacon Hill
Morristown, NJ, United States
Full-time

Responsible for performing extensive detailed data analysis necessary to ensure strict adherence to data quality guidelines.

This role will conduct full lifecycle activities to include requirements analysis and design, develop analytics and reporting capabilities, and continuously monitor performance and quality control plans to identify improvements and alerting of potential issues.

This person is essential to gaining a better insight into the client's business data deficiencies, formulating a data-driven approach to solve the problem and finally, analyzing and drawing conclusions and presenting them to the client.

This position is a client-facing role and is responsible for being able to communicate complex analytic findings and conclusions in an easy-to-understand way.

Required Qualifications

  • Senior level experience with SQL Data Analysis and SQL Querying and Development
  • Experience working with SQL daily and ability to write complex queries.
  • Experience in writing functional specification documentation and leading cross-functional initiatives across the enterprise.

Preferred Qualifications

Develop analytical strategies to solve business problems - this involves understanding the business problem, identifying relevant data, gathering and summarizing data meaningfully and applying appropriate statistical analysis to identify causal relationships and predict future outcomes.

Deliverable must be high quality with strong attention to detail.

Transform complex data into easy to follow reporting through graphing, charts and dashboards, utilizing tools such as SSRS, PowerPoint or Excel.

May also be required to present findings and reporting to clients and internal executive management.

  • Create repeatable jobs and procedures utilizing MS SQL Server platform to gather and analyze data, to evaluate effectiveness of controls, determine accuracy of reports and efficiency of operations.
  • Work with client customers and vendors, to analyze and provide solutions for their data issues
  • Collaborating with and influencing clients and customers to develop analytic models, methodologies and reports that support client products and services.
  • Prioritizing competing client requests to ensure focus on highest impact activities.
  • Experience working with various data feeds.
  • Experience extracting, manipulating, and analyzing data and then using it to draw relevant conclusions

Desired Skills and Experience

Responsible for performing extensive detailed data analysis necessary to ensure strict adherence to data quality guidelines.

This role will conduct full lifecycle activities to include requirements analysis and design, develop analytics and reporting capabilities, and continuously monitor performance and quality control plans to identify improvements and alerting of potential issues.

This person is essential to gaining a better insight into the client's business data deficiencies, formulating a data-driven approach to solve the problem and finally, analyzing and drawing conclusions and presenting them to the client.

This position is a client-facing role and is responsible for being able to communicate complex analytic findings and conclusions in an easy-to-understand way.

Required Qualifications

  • Senior level experience with SQL Data Analysis and SQL Querying and Development
  • Experience working with SQL daily and ability to write complex queries.
  • Experience in writing functional specification documentation and leading cross-functional initiatives across the enterprise.

Preferred Qualifications

Develop analytical strategies to solve business problems - this involves understanding the business problem, identifying relevant data, gathering and summarizing data meaningfully and applying appropriate statistical analysis to identify causal relationships and predict future outcomes.

Deliverable must be high quality with strong attention to detail.

Transform complex data into easy to follow reporting through graphing, charts and dashboards, utilizing tools such as SSRS, PowerPoint or Excel.

May also be required to present findings and reporting to clients and internal executive management.

  • Create repeatable jobs and procedures utilizing MS SQL Server platform to gather and analyze data, to evaluate effectiveness of controls, determine accuracy of reports and efficiency of operations.
  • Work with client customers and vendors, to analyze and provide solutions for their data issues
  • Collaborating with and influencing clients and customers to develop analytic models, methodologies and reports that support client products and services.
  • Prioritizing competing client requests to ensure focus on highest impact activities.
  • Experience working with various data feeds.
  • Experience extracting, manipulating, and analyzing data and then using it to draw relevant conclusions

Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. Individuals with Disabilities and Protected Veterans are encouraged to apply.

California residents : Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

If you would like to complete our voluntary self-identification form, please click here or copy and paste the following link into an open window in your browser :

Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment.

This form will be used for reporting purposes only and will be kept separate from all other records.

Company Profile :

Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services.

Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.

Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming / Development, Database, Infrastructure, Quality Assurance, Production / Support and ERP roles.

Learn more about Beacon Hill and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting .

We look forward to working with you.

Beacon Hill. Employing the Future™

1 day ago
Related jobs
Promoted
Beacon Hill
Morristown, New Jersey

Senior level experience with SQL Data Analysis and SQL Querying and Development. Senior level experience with SQL Data Analysis and SQL Querying and Development. Responsible for performing extensive detailed data analysis necessary to ensure strict adherence to data quality guidelines. This person i...

Beacon Hill
Morristown, New Jersey

Senior level experience with SQL Data Analysis and SQL Querying and Development. Responsible for performing extensive detailed data analysis necessary to ensure strict adherence to data quality guidelines. This person is essential to gaining a better insight into the client's business data deficienc...

Promoted
CACI
Wharton, New Jersey

Data Transformation Specialist/Database Developer. As a Data Transformation Specialist / Database Developer, you will play a critical role in modernizing and transforming legacy data tools into more modern, efficient systems, supporting the U. Analyze and assess legacy tools, including Excel trackin...

Promoted
Verizon
Bernards, New Jersey

Learn and provide the metrics required to support key business goals for different lines of business and segment reporting. Partner with other internal and external teams to help provide business intelligence by identifying the right data, conducting analyses, and providing insights to make recommen...

Promoted
PeopleShare
Hanover, New Jersey
Remote

PeopleShare is seeking a REMOTE Technical Business Analyst for an innovative, industry leading healthcare company! You will play a critical role in the client software development lifecycle, with emphasis on the upfront conception/design of new client programs, client enhancements, and development o...

Promoted
Dexter Technologies
Parsippany-Troy Hills, New Jersey

Business-to-Business durable able goods, construction, or building materials. C-Level, business stakeholders and technical teams. Perform analysis and design using various methods, including: business requirements, functional specifications, user stories/acceptance criteria, use cases, swim lanes, a...

Promoted
LTIMindtree
Warren, New Jersey

We are looking for a Data Scientist / AI-ML Engineer who will support building AI tools for customers. Mine and analyse data from databases to drive optimization and improvement of product development and business strategies. Assess the effectiveness and accuracy of new data sources and data gatheri...

Promoted
CoreWeave
Roseland, New Jersey

Collect, join, and maintain data in support of team objectives, while maintaining data quality and integrity and then digest data into consumable metrics for visualization. Reporting to the Manager of Data Science & Analytics for Capacity, this individual will help evolve our company's produ...

Promoted
Iris Software Inc.
Parsippany-Troy Hills, New Jersey

Required skills Data Scientist with GenAI - experience on LLM use cases, llama, openAI, Python. Conduct comprehensive data analysis and modeling, applying AI / ML and statistical methods to large datasets to effectively harness useful insights and generate creative outputs. ...

Promoted
Diverse Lynx
Morristown, New Jersey

Data Scientist for the Use Case Digital Follow. Nice to have: Text data processing, Document (PDF/Excel) processing. ...