Data Warehouse Administrator at Kavaliro
Orlando, FL
About the Job
Responsiblities
Kavaliro provides Equal Employment Opportunities to all employees and applicants. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Kavaliro is committed to the full inclusion of all qualified individuals. In keeping with our commitment, Kavaliro will take the steps to assure that people with disabilities are provided reasonable accommodations. Accordingly, if reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment, please respond to this posting to connect with a company representative.
- Develop and manage effective working relationships with other departments, groups, and personnel with whom work must be coordinated or interfaced.
• Establish and enforce data warehousing standards to meet requirements and business needs.
• Evaluate our current back-end processes. Create and improve the underlying data design and flow of information.
• Utilize Azure stick modules such as Data Factories, Data Lake, SQL DW and Synapse in support of ongoing
data warehouse and reporting needs.
• Assist in the overall architecture of the Azure Data Vault utilizing Data Vault 2.0 best practices.
• Interpret business requirements and actively provide input from data perspective.
• Build simple to complex pipelines and dataflows.
• Build reliable, scalable distributed systems for data analytics and reporting.
• Coach, guide, and mentor team members on Azure development best practices.
• Implement and maintain security and authorization framework modules.
• Integrate and maintain Row-Level Security (RLS) methodology.
• Conduct root cause analysis and resolve performance and production problems and data issues.
• Provide ongoing maintenance and support of Azure data environment.
• Document technical designs and architecture, workflow, dataflow and processes.
• Validate accuracy and consistency of the data in the database and test the developed routines.
• Meet professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner, and demonstrating respect for others.
• All work responsibilities are subject to having performance goals and/or targets established.
• Provide a minimum of weekly status report updates for current projects.
Qualifications:
- Bachelor’s Degree in Computer Science or Information systems or equivalent combination of education and relevant experience
- Minimum 2 years’ experience with MS Azure SQL Server and Azure Data warehouse environment
- Minimum 2 years’ experience with building, deploying, troubleshooting Data Extraction, and loading jobs using Azure data factory
- Minimum 5 years’ experience with Agile methodology and Scrum Framework
- Minimum 2 years’ DevOps experience and CI/CD methodology
- Minimum 5 years’ experience in authoring and troubleshooting SQL Queries, Stored Procedures and ETL Processes
- Proficiency in Python or PowerShell
Kavaliro provides Equal Employment Opportunities to all employees and applicants. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Kavaliro is committed to the full inclusion of all qualified individuals. In keeping with our commitment, Kavaliro will take the steps to assure that people with disabilities are provided reasonable accommodations. Accordingly, if reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment, please respond to this posting to connect with a company representative.
Salary
$65 - $70 per hour