Senior Software Engineer

Wayfair; Honolulu (HI); Hybrid; USD 139,464 - 168,800; Full time

Benefits offered by this job

Telecommuting within metropolitan area

Incentive eligible

Comprehensive benefits

Job summary

Vizient is seeking a data analytics and BI specialist to drive ETL pipelines, data modeling, and reporting across Oracle and SQL environments on Azure. You will design scalable data architectures, validate data integrity, and collaborate with cross-functional teams to deliver insights.

Strong SQL, Python, and visualization skills are required, with experience in Azure cloud technologies and data warehousing.

Qualifications

• Related degree, experience and skills required.
• Experience in Data Analysis, BI, ETL, Data Warehousing/Databases, SQL Server/Oracle PLSQL, Python, R, Azure Cloud, analytics and visualization tools.
• Experience with Microsoft BI, ETL/ELT, Data Modeling (ER-win, MS Visio), database/w data warehousing concepts, SSIS/SSAS/SSRS, Informatica, and data visualization.

Responsibilities

• Work with business product owners and leadership on agile projects to ensure compliance and efficiency.
• Access and interpret multiple data sources for sourcing activities and reporting.
• Migrate Oracle code to Azure environment and redesign architecture for efficiency.
• Configure ETL pipelines using Azure Data Factory and Synapse to schedule jobs.
• Create data models and diagrams to support scalable design and data integrity.
• Develop OLTP and data warehouse structures, monitor performance, and ensure security.
• Troubleshoot and debug processes, implement error handling, and ensure data quality.
• Lead code reviews and knowledge transfer sessions to improve processes and code quality.

Skills

Data Analysis

Business Intelligence

ETL

Python

SQL

Azure Cloud

Machine Learning

Data Modeling

Education

Bachelor's degree in a related field

Tools

SQL Server

Oracle PLSQL

SSIS

SSRS

Power BI

Tableau

Azure Synapse

Azure Data Factory

ER/Win

Job description

Responsibilities

• Work and collaborate with Business product owner, Business relationship managers, Security support team and site leaders on agile projects to ensure individual facility compliance and efficiency; access and interpret multiple data sources pertinent to team sourcing activities, including client internal data, supplier provided data, budget projections and user reports.
• Configure database/website with Star and Snowflake schema to ensure files adhered to standards and were of valid integrity before processing in Master database; work with server engineers to ensure proper builds of the new servers and SQL team to upgrade all servers to latest version.
• Work on Azure Synapse and Azure data factory by migrating Oracle code to Azure environment; redesign architecture and code to make it highly efficient, readable, and manageable; configure DataSync job on MS Azure to synchronize data between different environments; utilize synapse pipeline to kick off and schedule execution of the ETL jobs using triggers.
• Create data models using ER studio, ER-Win, SSMS tools; design several entity relationship and data flow diagrams following hierarchy of conceptual, logical and physical design phase; identify relationship among entities, keys, and constraints to understand architecture of application and to make a scalable design.
• Develop and maintain OLTP (online transaction processing) and Data Warehouse using facts and dimensions tables; select and prepare best fit model for optimal performance and reduce complexity; make decisions to choose between bottom-up and top-down approach; monitor ongoing running processes as well as execution plans for making enhancements and security checks.
• Troubleshoot and debug code and processes to verify and validate output/results and avoid erroneous data in the future; incorporate error handling techniques by utilizing try-catch statement and throw-raise error functions and come up with decisions of implementing relevant and accurate changes.
• Guide and lead team members to follow code standards and set up business domain knowledge transfer sessions to provide insights and learning of new processes and code development; work and pair with cross team members for code and technical reviews to deliver quality software.
• Work on object-oriented language (Python), .NET framework, TSQL code/queries and Angular to develop and support front end application and use GIT for version controlling facilitating easy rollback and disaster recovery of code base; follow TDD (Test Driven Development) to make sure each and every logic of the application is well-tested and reviewed.

Qualifications and Experience

• Related degree, experience and skills required.
• Experience in Data Analysis, Business Intelligence, ETL (Extraction Transformation Load), Data Warehousing/Databases, Microsoft SQL Server/Oracle PLSQL, Python, R language, Microsoft Azure Cloud Platform, Research Analytics, Statistical Modeling Programming, Algorithms, Machine learning, Big Data/Data Mining and Reporting (Tableau, Power BI, SSRS).
• Experience in Microsoft Business Intelligence, ETL/ELT, Data Modeling (ER-win, MS Visio), Database/Datawarehouse (OLTP/OLAP), TSQL Programming, Dynamic SQL, Integration Services (SSIS), Informatica, Analysis Services (SSAS, OLAP Cubes), Reporting Services (SSRS, Report Builder, MS Excel, PBId, Data Visualization) and Testing (UAT, smoke, regression).

Benefits

Telecommuting (work from home) permitted within metropolitan statistical area. Salary: $139,464.00 - $168,800.00. This position is also incentive eligible. Vizient has a comprehensive benefits plan! View benefits here: http://www.vizientinc.com/about-us/careers

Equal Opportunity Employer

Females/Minorities/Veterans/Individuals with Disabilities. The Company is committed to equal employment opportunity to all employees and applicants without regard to race, religion, color, gender identity, ethnicity, age, national origin, sexual orientation, disability status, veteran status or any other category protected by applicable law.