Annexa - NetSuite Solution Provider · 3 weeks ago
Senior SQL Developer
Washington, DC
Full-time
Onsite
Senior Level, Lead/Staff
16+ years expAnnexa Inc is currently working with DC Office of Unified Communications and they are seeking a Senior SQL Developer. The SQL Developer will be responsible for ensuring the accuracy, consistency, and integrity of data across various systems within the organization, conducting thorough data analysis, and collaborating with cross-functional teams to enhance data management practices.
Information TechnologyService IndustrySoftware
Responsibilities
Interfaces, independently, with high level stakeholders via meetings, emails, and phone calls to manage data projects. Gather and document requirements; and to gather sample data throughout all phases of the project to ensure data quality
Works with District agency resources to analyze, compile. verify, and query data as part of data warehousing services. Develops complex SQL queries used by reporting environments and data-driven dashboard applications Creates metadata and data dictionaries
Designs and documents methods to facilitate the implementation of new database systems. Designs and implements reports using SQL as well as a variety of reporting and business intelligence tools
Develops and administers data standards, policies and procedures; and develops new standards, methods, and techniques. Develops common approaches to problem solving and meeting processing requirements. Develops and analyzes new projects
Creates scripts to identify and correct common errors and data inconsistencies in incoming data. The incumbent will make extensive use of structured query language (SQL)
Troubleshoots problems involved in the input, retrieval or modification of database information and the general operation and maintenance pertinent to any of the enterprise data system elements or sub-elements
Perform complex data analyses including experience validating data and identifying and correcting data inconsistencies and errors. Analyzes and defines requirements and specifications pertinent to OUC and OCTO enterprise systems and applications. Analyzes and plans for anticipated changes in data capacity requirements. Evaluates the impact of technological changes; and/or conceives of solutions to highly complex technical issues. Operate and maintain Business Intelligence systems and ancillary systems for serving up data analytics
Coordinates all activities with the project manager throughout the full software development life cycle (SDLC). to include design, development, and testing
Works with minimal oversight as a technical lead on data-driven reporting and applications development projects
Keep abreast of current trends regarding all aspects of database management. Keep information of latest concepts, developments, approaches, and solutions to effective agency data management
Performs other related duties as assigned
Qualification
Required
Bachelor's degree in IT or related field or equivalent experience
16 yrs Extensive knowledge of a wide range of IT standards, principles, concepts, methods, policies, system testing principles and methods
16 yrs Extensive knowledge of authorized system approaches for IT pertinent to databases management
16 yrs Extensive knowledge of and skill in applying analytical methods and practices, and requirement analysis principles and methods
16 yrs Extensive knowledge in working with relational database technologies
10 yrs Extensive knowledge in creating metadata/data dictionaries; designing and implementing reports
10 yrs Extensive knowledge creating database views used for the purposes of establishing live data feeds as well as the development of data-driven dashboard
15 yrs Extensive knowledge of software development life cycle (SDLC), as well as, managing small IT projects with minimal oversight
15 yrs Extensive knowledge of data warehousing concepts; and extensive knowledge in working with data architects in the design of database schemas
10 yrs Knowledge of BI systems operations and maintenance
10 yrs Expert knowledge of and skill in applying oral and written communication techniques; and in evaluating and reporting on accomplishments
10 yrs Demonstrated ability to speak and write clearly and effectively when dealing with various technical and non-technical audiences
16 yrs Skill in data analysis, and SQL code development
Company
Annexa - NetSuite Solution Provider
Annexa are business system experts and award-winning NetSuite solution providers, working with forward thinking companies across Australia and New Zealand who are ready to take their business systems to the next level.
51-200 employees
H1B Sponsorship
Annexa - NetSuite Solution Provider has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (4)
2021 (3)
Funding
Current Stage
Growth StageCompany data provided by crunchbase