[Remote] TxDMV - Data Analyst - Senior BI Developer (Remote in Texas)
Note: The job is a remote job and is open to candidates in USA. The Texas Department of Motor Vehicles (TxDMV) is dedicated to serving and protecting the citizens and industries in Texas. They are seeking a Senior BI Developer to perform advanced development work in designing, implementing, and maintaining BI solutions, ensuring system security, and optimizing performance. The role involves collaborating with stakeholders to transform data into actionable insights through interactive dashboards and reports.
Responsibilities
• Collaborate with Stakeholders: Work with business users across various departments to understand their reporting and analytics needs and translate them into technical requirements
• Design & Develop BI Solutions: Design, build, test, and deploy interactive dashboards, reports, and data visualizations using BI platforms like Cognos and Power BI
• Data Modeling: Design, develop, and maintain scalable data models (e.g., star schemas, snowflake schemas) within the data warehouse or data marts to support reporting and analytical requirements
• ETL/ELT Development: Develop, optimize, and maintain Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) processes to integrate data from various source systems into the data warehouse or BI environment using tools like Informatica and Azure Data Factory
• SQL Proficiency: Write complex, efficient, and optimized SQL queries to retrieve and manipulate data for reporting and analysis
• Data Quality & Validation: Implement data quality checks and validation processes to ensure the accuracy, consistency, and reliability of BI solutions. Troubleshoot and resolve data discrepancies and performance issues
• Performance Tuning: Monitor and optimize the performance of BI dashboards, reports, and underlying queries/data models
• Documentation: Create and maintain clear technical documentation for BI solutions, including data dictionaries, data lineage, and process flows
• Support & Training: Provide support and training to end-users on BI tools and reports
• Stay Updated : Keep abreast of industry best practices, emerging trends, and new features in BI and data warehousing technologies
• May travel up to 5% of the time. Travels by car (may include flying). May include overnight travel. May require working extended hours and some evenings and weekends, as needed
• Required to attend work regularly and adhere to approved work hours in accordance with department policies and procedures
• Performs other duties as assigned
Skills
• Bachelor's or master's degree in the areas of computer science, math, or a related field, or equivalent experience
• Two (2) years of experience in a BI Developer Role creating ETL pipelines with a focus on Enterprise Analytics projects
• Five (5) years of experience working with a variety of relational databases (e.g. DB2, SQL Server)
• Two (2) years of experience in ETL development using industry-standard ETL tools (e.g., Informatica, Azure Data Factory, Microsoft Fabric)
• Two (2) years of experience in administration, configuration, development, and management of data storage, integration, and ETL solutions on cloud (AWS, Azure) and on premise
• Experience in building data pipelines in AWS or Azure public clouds
• A valid Class 'C' driver's license is required. If not currently a Texas resident, must obtain a Texas Driver's License within ninety (90) days after entering Texas as a new resident
• A satisfactory driving record is required for operating state or personal vehicles to conduct department business
• Five (5) years of experience with development following the Agile formal/structured methodology
• Five (5) years in implementing scalable and efficient data workflows, including data warehousing, data lakes, and data marts
• Four (4) years of experience in trouble shooting and performance tuning ETL Workflows and SQL
• Four (4) years of experience with batch processing in mainframe, DB2, or Oracle batch framework
• Two (2) years of experience with Data Governance and Data Catalog tools such as Informatica Data Catalog
• Proficient in scripting (SQL, R, Python, etc)
• Azure or AWS cloud certifications
• AI Knowledge will be preferred
Benefits
• Retirement Plan
• Paid Group Health & Life Insurance for employees
• Paid Holidays
• Paid Vacation Leave
• Paid Sick Leave
• Longevity Pay
• Dental
• Vision
• Dependent Optional Life Insurance
• Voluntary AD&D Insurance
• Dependent Health & Life Insurance
• Health & Dependent care flexible spending accounts
• Tuition Assistance Program
Company Overview
• The Texas Department of Motor Vehicles (TxDMV) is a dynamic state agency dedicated to customer service, consumer protection and the success of motor vehicle-related industries. It was founded in 2009, and is headquartered in Austin, Texas, USA, with a workforce of 501-1000 employees. Its website is https://www.txdmv.gov/.
Apply Now
Apply Now
Responsibilities
• Collaborate with Stakeholders: Work with business users across various departments to understand their reporting and analytics needs and translate them into technical requirements
• Design & Develop BI Solutions: Design, build, test, and deploy interactive dashboards, reports, and data visualizations using BI platforms like Cognos and Power BI
• Data Modeling: Design, develop, and maintain scalable data models (e.g., star schemas, snowflake schemas) within the data warehouse or data marts to support reporting and analytical requirements
• ETL/ELT Development: Develop, optimize, and maintain Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) processes to integrate data from various source systems into the data warehouse or BI environment using tools like Informatica and Azure Data Factory
• SQL Proficiency: Write complex, efficient, and optimized SQL queries to retrieve and manipulate data for reporting and analysis
• Data Quality & Validation: Implement data quality checks and validation processes to ensure the accuracy, consistency, and reliability of BI solutions. Troubleshoot and resolve data discrepancies and performance issues
• Performance Tuning: Monitor and optimize the performance of BI dashboards, reports, and underlying queries/data models
• Documentation: Create and maintain clear technical documentation for BI solutions, including data dictionaries, data lineage, and process flows
• Support & Training: Provide support and training to end-users on BI tools and reports
• Stay Updated : Keep abreast of industry best practices, emerging trends, and new features in BI and data warehousing technologies
• May travel up to 5% of the time. Travels by car (may include flying). May include overnight travel. May require working extended hours and some evenings and weekends, as needed
• Required to attend work regularly and adhere to approved work hours in accordance with department policies and procedures
• Performs other duties as assigned
Skills
• Bachelor's or master's degree in the areas of computer science, math, or a related field, or equivalent experience
• Two (2) years of experience in a BI Developer Role creating ETL pipelines with a focus on Enterprise Analytics projects
• Five (5) years of experience working with a variety of relational databases (e.g. DB2, SQL Server)
• Two (2) years of experience in ETL development using industry-standard ETL tools (e.g., Informatica, Azure Data Factory, Microsoft Fabric)
• Two (2) years of experience in administration, configuration, development, and management of data storage, integration, and ETL solutions on cloud (AWS, Azure) and on premise
• Experience in building data pipelines in AWS or Azure public clouds
• A valid Class 'C' driver's license is required. If not currently a Texas resident, must obtain a Texas Driver's License within ninety (90) days after entering Texas as a new resident
• A satisfactory driving record is required for operating state or personal vehicles to conduct department business
• Five (5) years of experience with development following the Agile formal/structured methodology
• Five (5) years in implementing scalable and efficient data workflows, including data warehousing, data lakes, and data marts
• Four (4) years of experience in trouble shooting and performance tuning ETL Workflows and SQL
• Four (4) years of experience with batch processing in mainframe, DB2, or Oracle batch framework
• Two (2) years of experience with Data Governance and Data Catalog tools such as Informatica Data Catalog
• Proficient in scripting (SQL, R, Python, etc)
• Azure or AWS cloud certifications
• AI Knowledge will be preferred
Benefits
• Retirement Plan
• Paid Group Health & Life Insurance for employees
• Paid Holidays
• Paid Vacation Leave
• Paid Sick Leave
• Longevity Pay
• Dental
• Vision
• Dependent Optional Life Insurance
• Voluntary AD&D Insurance
• Dependent Health & Life Insurance
• Health & Dependent care flexible spending accounts
• Tuition Assistance Program
Company Overview
• The Texas Department of Motor Vehicles (TxDMV) is a dynamic state agency dedicated to customer service, consumer protection and the success of motor vehicle-related industries. It was founded in 2009, and is headquartered in Austin, Texas, USA, with a workforce of 501-1000 employees. Its website is https://www.txdmv.gov/.
Apply Now
Apply Now