SQL BI Developer, Diverse Lynx, Frederick, MD
Diverse Lynx -
Frederick, MD,
US
SQL BI Developer
Date Posted: 2024-06-11
Job description
Must-Have 5+ years of expert TSQL/Procedural language and SSIS experience Strong SQL experience, specifically SQL Server 2012. Knowledge of data governance standards . dvance TSQL coding a must Hands on Dimensional Modeling Hands on data transformation with SSIS and SQL Agent for automation and scheduling Good understanding of Data warehouse concepts. zure working knowledge, don't need to be expert Tableau knowledge is good to have Job Responsibilities Defines, develops, and implements automation of reports, processes, and interfaces. Designs and develops models to improve financial analysis and to project financial impact of business changes. Interprets and translates accounting and finance business needs into effective applications and operational requirements to assist IT staff with implementation of finance and accounting system solutions. Works with IT and Finance to perform testing and facilitate implementation of data warehouses. Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data. Understands and compiles accurate data to present reports and assesses data quality. pplies a broad range of techniques and theories from business intelligence, data analysis and visualization, statistics, and predictive analytics to deliver actionable business insights based on large-scale data. Defines, captures, enriches, explores and preps data to support desired metrics monitoring and reports. Troubleshoots and resolves problems related to accounting and finance systems and applications. Skills: Extensive knowledge of SQL SQL Server Management Studio experience Extensive knowledge of complex data models Strong data analysis/mining experience Strong data validation skills Strong Experience with ETL tools Driving curiosity and attention to detail Reporting Provides thorough, visible, rigorous and transparent data reports and analysis. Tracks trends and provides recommendations for solutions based on findings. Interprets and communicates analytical insights to audiences with various analytical backgrounds using different but suitable communication methods for different audiences. Develops visually appealing and intuitive dashboards that provide visibility into key performance, risk, and control indicators across agency divisions and departments.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.