SQL Report Writer Data Analyst

SQL Report Writer / Data Analyst - CTP or Perm - Hollywood, FL - $45.00 - $50.00/hr.

The final salary or hourly wage, as applicable, paid to each candidate/applicant for this position is ultimately dependent on a variety of factors, including, but not limited to, the candidate's/applicant's qualifications, skills, and level of experience as well as the geographical location of the position.

The end client is unable to sponsor or transfer visas for this position; all parties authorized to work in the US without sponsorship are encouraged to apply.

Our client is seeking a SQL Report Writer / Data Analyst in Hollywood, FL.

Role Description

The incumbent in this position is responsible for the development, implementation and support of mission-critical enterprise Business Intelligence (BI) reports gathered from various production systems. The SQL BI Report Writer collaborates with business stakeholders, department leaders, and subject matter experts to develop and support BI information (reports, dashboards, etc.) This role involves creating impactful reports, analyzing data, and developing ETL processes to ensure seamless data integration. The incumbent in this position gathers requirements, performs analysis, and translates business reporting requirements to BI report technical specifications. Competent in other IT disciplines, including

Translates business requirements into specifications to be used to implement BI reports and dashboards, created from multiple sources to support the information analytics.
Performs unit and integration testing and participates in reporting validation and Quality Assurance (QA) efforts as they pertain to reporting and data analytics.
Prepares and delivers reports, recommendations, or alternatives for improving processes in reporting systems across the organization.
Advises department and managers regarding appropriate, effective, and efficient use of organizational reporting capabilities and functions.
Solid knowledge of SQL including creating view, tables and stored procedures for reporting purposes.
Prepare Business Reports by collecting, analyzing and summarizing information and trends.
Ability to work with many different departments, healthcare, accounting, ERP, and executives for reporting needs.
Interpret, evaluate data to develop integrated business analyses and projections for incorporation into strategic decision-making.
Collaborate with stakeholders to identify reporting needs and ensure reports align with business objectives while employing techniques which appropriately define alternative solutions.
Optimize reporting processes for accuracy, scalability and efficiency.
Integrate and transform data from various sources (e.g., relational databases, flat files, APIs, etc.) into structured formats for reporting and analytics.
Troubleshoot and optimize SSIS packages for performance and error handling.
Ensure data quality and integrity throughout the ETL process.
Analyze and interpret data to identify trends, patterns, and actionable insights.
Conduct insightful, ad-hoc data analysis to investigate and support business decisions and report writing.
Design, develop, and maintain interactive and visually appealing Power BI reports and dashboards.
Implement complex data models and DAX (Data Analysis Expressions) to ensure accurate and meaningful insights. Competent in writing Power BI Q&A queries.
Customize Power BI reports and dashboards to meet the specific needs of business users.
Perform Power BI report performance tuning and optimization.

Skills & Requirements

Advanced knowledge of SQL Server Reporting Services design, administration, and maintenance.
Thorough knowledge of indexing and T-SQL writing practices for efficient query writing.
Strong knowledge of T-SQL programming skills with the ability to write and optimize SQL code.
Prior experience with Microsoft Visual Studio, to create SSRS reports.
Familiarity with Active Directory (AD), AD groups, AD/SSRS permissions and migrations.
An ability to gather data from different information sources and distribute them to users; use this information to simplify information systems and make sound business decisions.
Demonstrate strong understanding of relational database structures, theories, principles, and practices.
Ability to work well in a collaborative environment.
Ability to work under strict deadlines and independently with little supervision, as well as multi-task and prioritize multiple projects.
Ability to communicate with non-technical users regarding technical issues.
Demonstrate strong problem-solving and analytical skills and possess high levels of motivation, initiative, and responsibility.
Bachelor's degree in Information Systems, Computer Science or related field is required.
A minimum of five (5) years of experience with SQL Server Reporting Services including designing, writing, administering, and maintaining them is required.
Prior experience with Power BI, SSIS and SSRS migration is required.
Prior experience troubleshooting and fixing query performance issues is required.
Prior professional experience using Microsoft Visual Studio, to create SSRS reports is required.
Prior experience with Crystal Reports is preferred.
Prior experience working with healthcare data is also preferred.
Possession of a valid Florida Driver's License is required.

Benefits/Other Compensation

This position is a contract/temporary role where Hays offers you the opportunity to enroll in full medical benefits, dental benefits, vision benefits, 401K and Life Insurance ($20,000 benefit).

Why Hays?

You will be working with a professional recruiter who has intimate knowledge of the industry and market trends. Your Hays recruiter will lead you through a thorough screening process in order to understand your skills, experience, needs, and drivers. You will also get support on resume writing, interview tips, and career planning, so when there's a position you really want, you're fully prepared to get it.

Nervous about an upcoming interview? Unsure how to write a new resume?

Visit the Hays Career Advice section to learn top tips to help you stand out from the crowd when job hunting.

Hays is committed to building a thriving culture of diversity that embraces people with different backgrounds, perspectives, and experiences. We believe that the more inclusive we are, the better we serve our candidates, clients, and employees. We are an equal employment opportunity employer, and we comply with all applicable laws prohibiting discrimination based on race, color, creed, sex (including pregnancy, sexual orientation, or gender identity), age, national origin or ancestry, physical or mental disability, veteran status, marital status, genetic information, HIV-positive status, as well as any other characteristic protected by federal, state, or local law. One of Hays' guiding principles is 'do the right thing'.
We also believe that actions speak louder than words.
In that regard, we train our staff on ensuring inclusivity throughout the entire recruitment process and counsel our clients on these principles. If you have any questions about Hays or any of our processes, please contact us.

In accordance with applicable federal, state, and local law protecting qualified individuals with known disabilities, Hays will attempt to reasonably accommodate those individuals unless doing so would create an undue hardship on the company. Any qualified applicant or consultant with a disability who requires an accommodation in order to perform the essential functions of the job should call or text .

Drug testing may be required; please contact a recruiter for more information.

#LI-DNI