SQL Developer - Apex Systems

Job#: 2040127

Job Description:

Job Summary:
This person will be responsible for performing the data analysis and profiling necessary to provide direction, standards, and implementation of data management solutions associated with data ingestion, transformation, integration, and analytics. They will engage in full stack Microsoft BI development activities to deploy usable and measurable projects meeting business needs leveraging tools such as SSIS, SSAS, stored procedures and Power BI.
Job Requirements:

• Resolve dead locks issues with the Databases/Servers on a real-time basis.
• Formulate procedures for data extraction, transformation, and integration of data.
• Create SSIS packages that generates transition of care for tailor plan and standard plan claim files.
• Pull data from Excelys and create different configuration and inventory SAS reports.
• Design Microsoft Power BI dashboards and manage power BI gateways with a focus on usability, performance, flexibility, testability, and standardization.
• Create scripts using DAX functions in Power BI Desktop.
• Develop measures using DAX language.
• Develop dashboards, analytical reports, KPIs based on business requirements. 
• Create complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Perform efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Create Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Document all work and process of integration and reporting services for further references.
• Create views to display required information on user interface, and triggers to validate consistent data entry into the database.

Preferred Experience:

• Minimum seven (7+) years’ experience in a multi-disciplined IT environment with strong expertise in data analysis, data modeling, data governance and involvement in enterprise architecture.
• Minimum of five (5+) years’ experience, hands-on, data profiling and performance tuning databases and data marts with Oracle and / or SQL Server.
• Experience with performance improvement using Azure and/or on-premise Microsoft technologies.
• Experience taking a lead role in architecting, designing, and developing solutions exceeding business expectations.
• Knowledge of interpreting business processes and requirements and translating them into logical and physical data models adhering to documented standards and best practices.
• Excellent problem solving and communication skills with experience in interacting with business and technical teams at all levels.

Work Schedule:

• Hybrid- 3 days onsite (Tues-Thurs), 2 days remote (Mon/Fri)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.