What are the responsibilities and job description for the SQL Developer Sr W2 ONLY position at United Global Technologies?
Key Responsibilities :
Data Orchestration, Automation and Pipeline technology solutions
Data Platform Tools Support (administration, maintenance, support, etc) relating to key platforms, such as PowerBI, SSIS / SSRS primarily with ability to handle backup support for other data platforms
Utilizing data fabrics and data virtualization platforms to optimize data delivery.
Managing and monitoring processes and tools that support data delivery and automation.
Develop, troubleshoot and optimize queries, views, and stored procedures to support data pipelines and automations.
Troubleshoot and help performance tune query processing supporting data reporting and delivery.
Collaborate within the data operations and governance teams to assess and troubleshoot potential data quality and discrepancy issues at key intake points within the data transformation layer.
Documents data platform processes, programs, and solutions as per established standards for data governance.
Integrates best practices within data pipeline processes to maximize object reuse.
Experience sourcing and moving data between database systems (Oracle / MS SQL / Postgres / etc)
Experience with data research, analysis, security, and data quality
Ability to create / read / modify / enhance SQL code and packages across database technologies.
Experience working within agile development teams and processes.
Familiarity with data protection regulations and compliance requirements for sensitive data.
Excellent analytical, problem-solving, and solutioning skills.
Good communication and interpersonal skills, with the ability to engage and collaborate with product owners / managers, application teams, architects, database administrators, and other technical areas or development teams as needed.
Minimum Requirements :
Requires an BA / BS degree in Information Technology, Computer Science or related field of study and highly prefer a minimum of 5 years of experience as a Report administrator, Developer, ETL tool administrator, or similar role in a data-centric environment.
Preferred Skills, Capabilities and Experiences :
5 years of experience in administering, testing, and implementing enterprise data process automation and orchestration.
Experience with Data processing platforms and technologies such as Microsoft SSIS, Informatica, ActiveBatch, Power Apps, Job Schedulers, File transfer tools, etc.
Responsible for providing full lifecycle administration of data platform tools (patches / updates, security, account management, capacity management, documenting processes, etc)
Primary platform support would revolve around PowerBI / SSRS / SSIS and supporting user security, but also serve as a backup for other department software platforms (Denodo, Informatica, ActiveBatch, etc.)
Data management & modelling : Connect and manage data pipeline tools to various data sources, including on-premise and cloud-based data sources.
Implement and maintain semantic models to ensure data integrity and performance optimization. Perform data cleansing and transformation tasks (ETL) to prepare data for analysis.
Technical support : Provide technical guidance and support to consumers of data services, ensuring effective adoption and utilization of enterprise data and the fabric / virtual layer.
Performance monitoring : Monitor and optimize Data Pipeline (ETL) performance, including capacity planning and server performance.
User management : Manage user access and permissions to enterprise data platforms and resources, ensuring compliance with security policies.
Troubleshooting : Conduct thorough testing, debugging, and troubleshooting of Data Pipleline (ETL) tools and solutions.
Governance : Maintain governance policies, best practices, and security standards for the enterprise data platforms.
Training and knowledge sharing : Provide training and share knowledge with colleagues to enable the delivery of data for enterprise needs.
Roadmap building and prioritization : Support the data architecture team with data pipeline (ETL) roadmap, prioritizing initiatives based on business needs and strategic goals
Skilled in analyzing and automating manual processes to reduce manual interaction
Experience with data virtualization / fabric platforms such as Denodo, CData, Talend, Data Virtuality
Experience with and utilizing development skills such as SQL, PL / SQL, T-SQL, Shell Scripting (PowerShell, Unix Shell, etc.)
Able to analyze, troubleshoot and tune SQL queries and recommend enhancements.
Analyzing and monitoring server resources and implement proactive alerts and notifications based on SLAs.
Performance tuning and analysis of SQL code and logic in data transformations and queries.
Relevant certifications related to data platforms and relevant technologies.
Experience in the healthcare claims processing industry and understanding of associated data security and privacy concerns.
Supporting staff and user community for normal business hours according to EST. Some on-call and platform support after hours / weekends would be required. Hours : Starts between 7am and end 4-6pm each day potential rotating shifts every 3-4 weeks
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a SQL Developer Sr W2 ONLY?
Sign up to receive alerts about other jobs on the SQL Developer Sr W2 ONLY career path by checking the boxes next to the positions that interest you.
