T-SQL Data Analyst Job at Beacon Hill in Morristown

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: https://jobs.beaconhillstaffing.com/eeoc/

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 www.bhsg.com.

We look forward to working with you.

Beacon Hill. Employing the Future™