Data Architect 1 (Sr. Data Analyst)

< style="margin: 0in; text-align: justify;">***Contract with Possible Extension or Hire***< style="margin: 0in; text-align: justify;"> < style="margin: 0in; text-align: justify;">Essential Duties and Responsibilities:< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Lead refinement, validation, and ongoing documentation of the existing enterprise data dictionary.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Work directly with business SMEs to elicit, clarify, and confirm data definitions, calculations, and business rules.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Function as a business analyst when needed to bridge gaps between business understanding and technical implementation.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Support and collaborate with business analysts by validating data logic and ensuring consistency across requirements, reports, and applications.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Design, develop, and maintain reports using Power BI and SSRS.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Assist with conversion and redevelopment of reports impacted by application migrations.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Provide advanced SQL Server expertise including complex queries, functions, and stored procedures.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Support data warehouse development and optimization including indexing strategies.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Query system tables and analyze performance and data behavior to support reporting and application needs.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Translate business logic into clear, actionable technical specifications for reporting and analytics.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Identify data quality issues and partner with technical teams to define and implement resolutions.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Document data lineage, transformations, and report logic clearly and consistently.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Communicate progress, risks, and data related issues to the IT Project Manager.< style="text-align: justify; text-indent: -.25in; mso-list: l0 level1 lfo1; margin: 0in 0in 0in .25in;">·         ·Perform other related duties as assigned.< style="margin: 0in; text-align: justify;"> < style="margin: 0in; text-align: justify;">Required/Desired Skills:

 

Skill	Required /Desired	Amount	of Experience
Professional data analysis or business intelligence experience	Required	7 Years
Demonstrated experience working in existing production environments under time constraints	Required	0
Advanced SQL Server knowledge performance tuning and table partitioning	Required	0
Demonstrated experience with Power BI and or SSRS	Required	0
Strong experience working with data warehouses	Required	0
Demonstrated experience eliciting and documenting requirements directly from business stakeholders	Required	0
Ability to work directly with SMEs, business analysts, developers, and project managers	Required	0
High level of attention to detail and strong documentation skills	Nice to have	0
Strong written and verbal communication skills	Desired	0
Experience supporting financial, tax, or property related systems	Highly desired	0
Experience assisting with system migrations or large-scale report conversions	Highly desired	0
Experience independently validating data logic and resolving ambiguity	Highly desired	0
Experience working in public sector or highly visible environments	Highly desired	0