Mind Over Machines ? Baltimore, Maryland
Marketing Intelligence Data Developer (SQL Server Environment) - #144
In this role, you will be developing programs to support reports, dashboards, and modeling. You will be also developing ETL to build out a data reporting warehouse as well as debugging and bringing efficiency to current data programs. Your stellar TSQL and Database Warehousing Skills will be critical to your success in helping our team continually deliver new and innovative solutions.
Our Marketing Intelligence Data Developer must be able to thrive in a fast-paced environment and demonstrate a method of thinking acquired from years of problem-solving experience in the field. Excellent communication skills (both written and verbal) and a strong aptitude for relational database design and development are a must. To be successful in this role the developer must be very proactive, being able to balance multiple warehousing projects\defects concurrently and be able to execute the department?s vision prescribed with initiative, thoughtfulness, and a high regard to quality.
Duties and Responsibilities
? Continually evaluate new technologies and keep up to date with current technology enhancements to meet current and future business intelligence, reporting, and application development needs.
? Be able to effectively elicit and interpret business requirements and translate them into logical and physical data models.
? Provide solutions and technical input during conceptual solution discussions from an architectural and application perspective.
? Lead and own database ETL development and database deployment \ maintenance activities.
? Maintain a flexible work schedule to meet various demands of client support and on-call requirements (limited).
? Implement and enforce effective development lifecycle practices as well as to serve as a steward for developing quality driven solutions.
? Review and take ownership of the data landscape. Implement necessary and recommend defects \ enhancements. Ensure performance, security, and availability of the databases.
? Strong experience in databaseagile and waterfall development along with managing multiple environments and diverse application dependencies.
? Extensive understanding of relational databasearchitectures, techniques, and methodologies to support application and reporting needs with schema, dimensional, and aggregation techniques.
? Must have a strong background in supporting BI reporting tools from a database perspective.
? Strong understanding of advanced SQL techniques including performance, availability, scalability, security, and maintainability concepts.
? Skilled at debugging and optimizing complicated TSQL and ETL code.
? Capable of troubleshooting common database issues.
? Must understand database and ETL design principles and best practices, while also having a general idea on how to develop at an enterprise scale.
? 5+ years? of experience working in a SQL Server environment and using SQL Server Integration Services as an ETL tool.
? 5+ years? development experience object-oriented programming language.
? Proficient understanding of code versioning tools.
? Must possess excellent interpersonal skills including strong written and verbal communication.
? Must be able to clearly articulate and document standards and procedures.
? Must be able to hold themselves to a high level of quality coding outputs with minimal oversight.
? Must be able to manage and prioritize their own work and meet agreed upon deadlines.
? Must be able to work and integrate as needed with various project teams.
? Must be willing and motivated to learn about the marketing business.
? Must have a proactive approach to application support.
? Knowledge of Big DataTechnology?s or Analytical tools a plus