What are the responsibilities and job description for the Senior SQL and Power BI Developer | Remote position at Trinus?
Skills :
- Strong understanding of relational database concepts, SQL (Structured Query Language), and data modeling. Knowledge of various databases used in data warehousing, such as Oracle, SQL Server, PostgreSQL, or MySQL.
- Proficiency in ETL tools like Azure Data Factory, Azure Synapse, or Microsoft SSIS (SQL Server Integration Services) to extract data from various sources, transform it to fit the target schema, and load it into the data warehouse.
- Ability to design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysis.
- Understanding of data integration techniques and data quality processes to ensure data accuracy, consistency, and reliability in the data warehouse.
- Knowledge of data warehouse architecture principles, such as data staging areas, data marts, data lakes, and the overall data flow.
- Familiarity with data warehouse development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses.
- Proficiency in scripting languages like Python, Perl, or Shell scripting for automating ETL processes and data manipulation.
- Understanding of data security principles and compliance regulations to protect sensitive information in the data warehouse.
- Skills in optimizing data warehouse performance, including query optimization, index creation, and partitioning.
- Ability to collaborate with business stakeholders to gather and document reporting requirements, translating them into effective and performance-optimized Power BI dashboards and reports. This includes designing visually engaging, user-friendly layouts aligned with key performance indicators, as well as implementing row-level security, advanced DAX measures, and interactive visuals to deliver clear, actionable insights.
Experience Required :
Education Required :
Trinus Corporation, a leading provider of technology solutions and services with over 25 years of experience, is a certified WBE / MBE / SBE / SDB firm accredited by WBENC, NMSDC, and SBA.
Our mission is to shape the future of work by aligning the right mix of people, process, technology, and innovation to efficiently meet our clients' business objectives.
At Trinus, we understand that finding the right opportunity is pivotal in your career journey. Our staffing services go beyond mere placements; they are about matching your skills and aspirations with the perfect fit.
To learn more about us, please visit our website www. trinus.com
