Sql bi developer job description

Job Description • With the incumbent vendor, facilitate ETL processes of a longitudinal data warehouse with a data lake, including but not limited to rolling the system into the new school year, loading data, and maintaining current ETL code.

• Perform data validation to ensure data display accurately in the backend tables as well as published reports.

• Create ad hoc SQL queries to answer a wide range of inquiries of the system, from troubleshooting problems to formal data requests.

• Monitor the system, including but not limited to the nightly jobs and load performance; utilize the vendor-created solution to monitor processes and applications of the system.

• Perform organizational tasks that keep the system and documentation up to date, including but not limited to managing security, updating technical documentation, identifying systemic problems, and utilizing a vendor-created metadata management application, as well as maintaining reports, jobs, and stored procedures.
• Develop MicroStrategy dossiers or dashboards
• Create and update existing SQL Reporting Services (SSRS) reports and PowerBI reports.
• Load assessment files into the database using a vendor-created solution.
• Monitor the vendor-created identity management solution.
• Maintain SD-STARS security for users by monitoring the jobs and processes, raising possible concerns, and implementing security for reports and dashboards.
• As a member of the technical team, participate in planning and status meetings.
• As a member of the technical team, assist other team members with the system when needed.

QUALIFICATIONS
The successful candidate
must
have the following knowledge and experience for this position:
• Bachelor's degree plus 3+ years of experience in systems development with emphasis on data conversion and ETL;
• 3+ years of experience programming in Transactional SQL (TSQL);
• 3+ years of experience in ETL development;
• 2+ years of experience in SSRS;
• 2+ years of experience developing MicroStrategy reports and dashboards;
• 2+ years of experience developing PowerBI dashboards;
• Experience in identifying and communicating complex and technical issues followed by developing recommendations and facilitating resolution with stakeholders;
• Working knowledge of data modeling in data warehouses, cubes, etc;
• Working knowledge of effective data conversion methods and approach;
• Working knowledge of data conversion complexities;
• High level of attention to detail – thoroughness, and accuracy when accomplishing tasks;
• Excellent communications skills, both verbal and written;
• Professional demeanor – communicates with stakeholders in a friendly, unbiased, and professional manner;
• Ability to maintain effective working relationships with BIT, DOE, and vendor staff;
• Ability to work within a demanding project environment;
• Ability to follow, update, and create documentation of work processes;
• Ability to keep information confidential and abide by security standards and laws (ex: FERPA); and
• Ability to pass background security check (including fingerprinting).

The successful candidate
should
have the following knowledge and experience for this position:
• Proficient in relational database and data warehouse – design, creation, optimization, and refactoring SQL databases;
• Proficient in the development of stored procedures, triggers, functions, SSIS, SSRS, and PowerBI;
• Proficient in the development of MicroStrategy dossiers and dashboards;
• Knowledgeable in the use of Azure DevOps (ADOS) source control including branching and merging;
• Knowledgeable in SQL performance tuning, including use of the query store;
• Knowledgeable in SQL replication technologies;
• Experience in translating non-technical client requirements into information technology solutions;
• Experience in unit and functional testing on developed applications;
• Familiar with Software Development Life Cycle (SDLC) concepts;
• Familiar with Agile and/or Scrum development methodologies; and
• Ability to perform these functions with minimal supervision.

Genesis10 is seeking a Sr SQL BI Developer
for a leading company in Streetsboro, OH. This is a direct hire position that will be hybrid.



Job Duties:


Manage full life cycle development of business intelligence solutions and reporting.
Provide technical leadership, guidance, and support across multiple projects leveraging commonly used BI and advanced analytic tools.
Develop modern analytical dashboards with an eye to usability and intuitive user experience.
Develop simple and powerful charts and drilldowns by leveraging analytical and graphing components.
Develop multi-dimensional data warehouses and data models to pre-aggregate and organize data for analytical consumption.
Work closely with other Developers, Product Managers, UX designers, and Data Engineers.
Collaborate with other team members to develop and deploy the applications.
Research different software tools and maintain documentation of solutions.
Design databases to support Healthcare applications, ensuring system scalability, security, performance, and reliability.
Develop database architectural strategies at the modeling, design, and implementation stages to address business or industry requirements.
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
Develop data models for applications, metadata tables, views, or related database structures.
Develop advanced SQL procedures.
Create mission critical software with all necessary error handling.
Create/manage execution of BI roadmap.
Other duties as assigned.


Requirements:

5+ years of experience in the full life cycle of designing and developing Business Intelligence Solutions using Microsoft SQL Server technologies.
3+ years of experience with Microsoft Power BI.
Expertise in sophisticated relational database report design, development and maintenance using reporting tools such as SSRS & Power BI.
Experience developing and optimizing Transact-SQL Stored Procedures.
Experience with Relational Database & Data Warehouse Design/Development.
Experience with Performance Tuning for various SQL Server Database/Datawarehouse objects.
Experience leveraging error handling via TRY/CATCH with event logging.
Experience working with Cloud technologies like Microsoft Azure.
Experience with SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
Critical Thinking Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
Complex Problem Solving Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
Active Learning Understanding the implications of new information for both current and future problem-solving and decision-making.
Active Listening Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
Judgment and Decision Making Considering the relative costs and benefits of potential actions to choose the most appropriate one.
Excellent written and verbal communication skills
Organized, detail oriented
Able to communicate technical scenarios at both a high-level and detailed level as required by audience Bachelor's Degree in Computer Science or Information Technology is required.


If you are a qualified candidate interested in this opportunity, please apply.



About Genesis10:

Genesis10 is a leading U.S. business and technology consulting firm with hundreds of clients needing proven talent and solutions to power their strategic initiatives. If you are a high performing business or IT professional with solid, referenced experience, we want to meet you. Genesis10 recruiters and delivery professionals are highly accomplished career advocates, who get to know you beyond your resume to position you with the opportunities that fit your skills, experience, and aspirations. We have benefit options to fit your needs and a support staff that works with you from placement throughout your engagement project after project. To learn more about Genesis10 and to view all our available career opportunities, please visit us at www.genesis10.com .

Remote Position

12-month contract


Solugenix is assisting a client, a prestigious health insurance company, in their search for a Lead SQL Reports Developer. This is a 12-months contract opportunity based out of Los Angeles, CA with remote options.

The Lead SQL Reports Developer provides business insights, serves as the focal point for data review and remediation in peak work periods, and develops a range of complex formal reports for government entities. The Lead SQL Reports Developer will work closely with the IT. enterprise data warehouse and application development teams. The Lead SQL Reports Developer will represent the Department at key multi-disciplinary and technical meetings that impact the department's policies, procedures, and supporting technical systems. The Lead SQL Reports Developer will work with claims, member services, finance, and compliance departments to provide guidance and information on provider data related issues. The Lead SQL Reports Developer will develop expert level knowledge of the systems data structures in client's three core systems and provide and high-level advice and guidance to management on systems development and data integration.

The Lead SQL Reports Developer will work with Client's Information Technology and Compliance departments to submit a range of mandatory provider network reports for local, state, and federal government entities. These reports will require significant preparation, data integration from multiple data sources, review, and validation before client delivers them to the requesting entity. The complexity of the reports will require a thorough understanding of database systems, provider data, provider types, encounters, and experience with compliance reports in a managed care environment.

The Lead SQL Reports Developer will respond to inquiries for operational insights from a range of departments and will develop and test complex queries against two complementary, although separate databases. The Lead SQL Reports Developer will develop operational reports and metrics that support the PNO Department Key Performance Indicators (KPI).

The Lead SQL Reports Developer will act as the provider data Subject Matter Expert (SME) for requirements analysis, data analysis, data mapping, report development and testing, report modifications and documentation. The Lead SQL Reports Developer will develop and refine quality review programs to maintain the integrity and reliability of provider data. The SQL Reports Developer will be actively involved in resolving escalated issues interfering with the accurate and timely use of provider data throughout client and must have well-developed problem-solving skills. This position will research, audit and analyze data that is of an extraordinarily complex level."

Qualifications:

+ Bachelor's Degree or equivalent education.

+ At least 5-7 years of direct experience developing complex reports derived from a SQL or (Oracle) databases in a Managed Care environment which includes developing complex reports to external regulators and other entities with 3 years lead experience in a reporting, BI, or analytics team.

+ SQL Server is the primary database.

+ Hands-on experience creating all key database objects - Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL; Significant experience with SQL*Loader, TOAD, and Korn Shell programming.

+ Have well develop project management skills and experience leading a project that improved data integrity.

+ Strong database (SQL Server) experience in a RDBMS environment.

+ Strong general ETL / data integration experience; Experience developing/managing large-scale databases."

+ Extensive knowledge on SQL, SQL*Plus.

+ Must have the ability to code complex functions, and procedures.

+ Proven ability in overseeing SQL & Oracle databases of 500+ GB in sizes.

+ Ability to design and develop the database based on established requirements, including modifying any existing SQL database structure, as necessary.

+ Ability to maintain application performance and scalability; focus on performance tuning SQL queries, table design, indexing, query plan analysis and SQL refactoring.

+ Ability to develop proactive working relationships with Providers and other managed care organizations to determine business and functional requirements and identify solutions to resolve needs.

+ Ability to provide architectural/database technical expertise to team concerning methods, procedures, and standards to be used during design and development phases.

+ Ability to develop technical documentation and operational procedures for areas of responsibility.

+ Ability to create test plans, test data sets and automated testing to ensure all components of the system meet specifications; Investigate and fix defects; pre- and post-release.

+ Ability to troubleshoot/resolve complex database issues.

+ Proficient in database modeling & design with a focus on performance and scalability.

+ Excellent organizational skills with the ability to achieve results within tight deadlines.

+ Strong customer service orientation.

+ Excellent verbal and written communication skills.

+ Work under limited supervision.

+ SQL Server, T-SQL, healthcare experience is required. Qnext and Cactus are optional.

Responsibilities:

+ Lead complex data reviews, develop complex formal reports, and audit provider data.

+ Make or recommend ongoing changes to systems to better deliver provider data internally and externally.

+ Oversee the quality of all outbound files and data transfers.

+ Develop accurate formal reports to 'C-level' staff at client and formal reports and audits to state and federal audiences.

+ Provide an audit trail for provider data and be able to review and respond to complex regulator data questions.

+ Develop and implement data improvement projects.

+ Provide technical consulting and respond to error reports, problems and/or questions, Plan for backup and recovery of database information.

+ Lead data quality efforts and develop appropriate policy where needed.

+ Review the application of all provider data throughout the client systems environment and seek lasting solutions.

+ Develop policy, procedures, and reports tailored to the various user groups at client such as claims that identify provider issues, and moreover make recommendations as to how the issues could be resolved.

+ Prepare and deploy complex schema updates, data migration and ETL scripts.

+ Undertake ad-hoc queries and develop reports to support the Department.

+ Allocate system storage and plan future storage requirements for the database.

+ Follow and contribute to team standards and utilize industry best practices.

+ Timely, relevant, and actionable reports to frontline users and supervisors on provider data issues. Enroll users and design system security.

+ Assist frontline staff resolve provider data issues through an in-depth knowledge of the data and upstream and downstream processes.

+ Guide and mentor business analysts and other report writers in the department and for those staff working on provider data at client.

+ Become a key resource that can actively contribute to the fault finding and resolution process when problems are identified with provider data.

+ Mentor and train staff so they learn, understand and able to navigate the complexity of provider data.

+ Organize and attend meetings and present/discuss provider data, data schema, and systems with technical and business stakeholders.

+ Present the desired provider data view and ensure that provider data is being extracted and interpreted appropriately.

+ When new requirements are uncovered, develop a plan to deliver provider data to the client (internal or external).

+ Become a key member on data governance. Committees.

+ Perform other duties as assigned.

About the Client

Our client is one of the world's leading health insurance companies based out of Los Angeles, CA.

About Solugenix

Solugenix is an information technology services company known for its deep experience and knowledge in providing comprehensive technology services, solutions, and talent support for companies around the world. The company offers a variety of cutting edge and talent support solutions to promote growth and cutting-edge advancement to our esteemed clients and candidates. We provide these talent support solutions on a contract, contract-to-hire, and direct hire basis. We also have additional resources from our staffing partners to ensure the right match and expertise for the best result.

For over 50 years, global and local brands have trusted Solugenix as an added resource and partner in taking steps to ensure their immediate and future success. In addition to generating ground-breaking, industry-defining solutions, Solugenix has been delivering the talent and support needed to make it happen. We are dedicated to partnering with clients and candidates whose core values also foster a culture of professionalism, teamwork, and integrity.

External Company Name: Solugenix Corp

External Company URL: www.solugenix.com

Street: 1055 W. 7th Street

Telecommute: No